SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Ludovic FERRE
-- Create date: 2009-09-05
-- Description:	Retrieve Asso per prev_id
-- =============================================
CREATE PROCEDURE getAssoByPrevId
	@PREV_ID nvarchar(50)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT AD FROM ADHERENT WHERE PREV_ID=@PREV_ID
END
/* exec getAssoByPrevId '4711177V' */
GO
